Round 1 - Technical

🔹 This is the initial screening round.

🔹 Starting 30 mins had to solve SQL Coding questions (Leetcode medium, hard level).

🔹 Past projects discussion, how I handled scale and volume. Concepts asked : Data modelling, difference between fact and dim tables, SCD Types, Joins.

🔹 Spark cluster configuration and resource calculations.

Round 2 - Craft Demonstration

🔹In this round a problem statement was shared with me in advance.

🔹I was expected to prepare the solution and put it on PPT. I prepared the architectural design and defined the data models and test cases.

🔹This is a 90min round where interviewers were interested in my approach to the problem.

Round 3 - Technical Coding

🔹 This was a 60-minute hands-on technical round. I was asked to solve advanced SQL problems and answer.

🔹 Pyspark coding questions: Repartition vs Coalesce, Broadcast join. Spark architecture and Deploy modes in spark.

🔹 Some edge cases related to the craft demonstration I presented.

Round 4 - AI concepts

🔹 Asked about my knowledge on Gen AI, LLMs and basics of ML.

Round 5 - Hiring Manager interview

🔹 Detailed discussion on past projects.

🔹 How I handle conflicts in my team.

🔹 What aspects of team culture and collaboration matter most to me.